# -*- coding: utf-8 -*-
# @Time: 2025/7/13 8:23
# @Author: foxhuty
# @File: exam_room_notes.py
# @Software: PyCharm
import pandas as pd


file_path = r'D:\data_test_files\高2023级高三上期末成绩数据.xlsx'
df = pd.read_excel(file_path, sheet_name='物理类')
df.columns = df.columns.str.strip()
print(df.columns.tolist())
subject_candidate_number = [col for col in df.columns.tolist() if col in ['考号', '考生号']][0]
print(subject_candidate_number)

